inherited frmFixAssetInitList: TfrmFixAssetInitList
  Left = 420
  Top = 186
  Caption = #22266#23450#36164#20135#21021#22987#21270#28165#21333
  ClientHeight = 423
  ClientWidth = 882
  ExplicitWidth = 900
  ExplicitHeight = 494
  PixelsPerInch = 119
  TextHeight = 12
  inherited Panel1: TPanel
    Width = 882
    ExplicitWidth = 817
    inherited img3: TImage
      Left = 559
      ExplicitLeft = 494
    end
    inherited edtFilter: TcxTextEdit
      ExplicitHeight = 20
    end
  end
  inherited pnlMain: TPanel
    Width = 882
    Height = 323
    ExplicitWidth = 817
    ExplicitHeight = 323
    inherited MainDataGrid: TcxGrid
      Width = 882
      Height = 323
      ExplicitWidth = 817
      ExplicitHeight = 323
      inherited MainDataGridDBTableView: TcxGridDBTableView
        object colcardcode: TcxGridDBColumn
          Caption = #36164#20135#21345#29255#32534#21495
          DataBinding.FieldName = 'cardcode'
          Width = 80
        end
        object colAssetCode: TcxGridDBColumn
          Caption = #22266#23450#36164#20135#32534#21495
          DataBinding.FieldName = 'assetcode'
          Width = 90
        end
        object colName: TcxGridDBColumn
          Caption = #22266#23450#36164#20135#21517#31216
          DataBinding.FieldName = 'name'
          Width = 90
        end
        object colFTNAME: TcxGridDBColumn
          Caption = #22266#23450#36164#20135#31867#21035
          DataBinding.FieldName = 'ftname'
          Width = 80
        end
        object coluseddate: TcxGridDBColumn
          Caption = #20837#24080#26085#26399
          DataBinding.FieldName = 'useddate'
          Width = 80
        end
        object colPrice: TcxGridDBColumn
          Caption = ' '#21333#20215
          DataBinding.FieldName = 'price'
          Width = 60
        end
        object colQuantity: TcxGridDBColumn
          Caption = #25968#37327
          DataBinding.FieldName = 'quantity'
          Width = 55
        end
        object colStartRawAmt: TcxGridDBColumn
          Caption = #21407#22987#21407#20540
          DataBinding.FieldName = 'StartRawAmt'
          Width = 60
        end
        object colRawAmt: TcxGridDBColumn
          Caption = #20837#36134#21407#20540
          DataBinding.FieldName = 'rawamt'
          Width = 60
        end
        object colfdmname: TcxGridDBColumn
          Caption = #25240#26087#26041#27861
          DataBinding.FieldName = 'fdmname'
          Width = 80
        end
        object colSumDeprAmt: TcxGridDBColumn
          Caption = #32047#31215#25240#26087
          DataBinding.FieldName = 'sumdepramt'
        end
        object colNetValue: TcxGridDBColumn
          Caption = #20928#20540
          DataBinding.FieldName = 'netvalue'
          Width = 60
        end
        object colPlanUseMonth: TcxGridDBColumn
          Caption = #39044#35745#20351#29992#26376#20221
          DataBinding.FieldName = 'planusemonth'
          Width = 60
        end
        object colsumusedmonth: TcxGridDBColumn
          Caption = #24050#35745#25552#26376#20221
          DataBinding.FieldName = 'sumusedmonth'
          Visible = False
          Width = 64
        end
        object colstartsumusedmonth: TcxGridDBColumn
          Caption = #26399#21021#35745#25552#26376#20221
          DataBinding.FieldName = 'startsumusedmonth'
          Width = 64
        end
        object colPlanWorkValue: TcxGridDBColumn
          Caption = #39044#35745#24037#20316#24635#37327
          DataBinding.FieldName = 'planworkvalue'
          Width = 60
        end
        object colsumworkedvalue: TcxGridDBColumn
          Caption = #24050#35745#25552#24037#20316#37327
          DataBinding.FieldName = 'sumworkedvalue'
          Visible = False
          Width = 64
        end
        object colstartsumworkedvalue: TcxGridDBColumn
          Caption = #26399#21021#35745#25552#24037#20316#37327
          DataBinding.FieldName = 'startsumworkedvalue'
          Width = 64
        end
        object colFilName: TcxGridDBColumn
          Caption = #26426#26500#21517#31216
          DataBinding.FieldName = 'filname'
          Width = 90
        end
        object colworkunit: TcxGridDBColumn
          Caption = #24037#20316#37327#21333#20301
          DataBinding.FieldName = 'workunit'
          Visible = False
          Width = 60
        end
        object colforeignamt: TcxGridDBColumn
          Caption = #22806#24065#37329#39069
          DataBinding.FieldName = 'foreignamt'
          Visible = False
          Width = 60
        end
        object colmoneyname: TcxGridDBColumn
          Caption = #24065#31181
          DataBinding.FieldName = 'moneyname'
          Visible = False
          Width = 80
        end
        object colfntname: TcxGridDBColumn
          Caption = #22686#21152#26041#24335
          DataBinding.FieldName = 'fntname'
          Visible = False
          Width = 80
        end
        object colfsname: TcxGridDBColumn
          Caption = #20351#29992#29366#20917
          DataBinding.FieldName = 'fsname'
          Visible = False
          Width = 80
        end
        object colSpecific: TcxGridDBColumn
          Caption = #35268#26684#22411#21495
          DataBinding.FieldName = 'specific'
          Visible = False
          Width = 80
        end
        object collocation: TcxGridDBColumn
          Caption = #23384#25918#20301#32622
          DataBinding.FieldName = 'location'
          Visible = False
          Width = 80
        end
        object colRemainAmt: TcxGridDBColumn
          Caption = #39044#35745#20928#27531#20540
          DataBinding.FieldName = 'remainamt'
          Visible = False
          Width = 60
        end
        object colRemainRate: TcxGridDBColumn
          Caption = #27531#20540#29575#65288'%'#65289
          DataBinding.FieldName = 'remainrate'
          Visible = False
          Width = 60
        end
        object colmonthdepramt: TcxGridDBColumn
          Caption = #26376#25240#26087#39069
          DataBinding.FieldName = 'monthdepramt'
          Visible = False
          Width = 60
        end
        object colmonthdeprrate: TcxGridDBColumn
          Caption = #26376#25240#26087#29575
          DataBinding.FieldName = 'monthdeprrate'
          Visible = False
          Width = 60
        end
        object coldeproption: TcxGridDBColumn
          Caption = #25353#21407#20540#25110#20928#20540#25240#26087
          DataBinding.FieldName = 'deproption'
          Visible = False
          Width = 60
        end
        object colCleared: TcxGridDBColumn
          Caption = #26159#21542#28165#29702
          DataBinding.FieldName = 'cleared'
          Visible = False
          Width = 60
        end
        object colAddr: TcxGridDBColumn
          Caption = #20135#22320
          DataBinding.FieldName = 'addr'
          Visible = False
          Width = 80
        end
        object colvendorname: TcxGridDBColumn
          Caption = #20379#24212#21830
          DataBinding.FieldName = 'vendorname'
          Visible = False
          Width = 80
        end
        object colproducename: TcxGridDBColumn
          Caption = #21046#36896#21830
          DataBinding.FieldName = 'producename'
          Visible = False
          Width = 80
        end
        object colsjname: TcxGridDBColumn
          Caption = #22266#23450#36164#20135#31185#30446
          DataBinding.FieldName = 'sjname'
          Visible = False
          Width = 80
        end
        object coldprsjname: TcxGridDBColumn
          Caption = #32047#35745#25240#26087#31185#30446
          DataBinding.FieldName = 'dprsjname'
          Visible = False
          Width = 80
        end
        object colybastdebit: TcxGridDBColumn
          Caption = #24180#21021#21407#20540
          DataBinding.FieldName = 'ybastdebit'
          Visible = False
          Width = 60
        end
        object colsumdebit: TcxGridDBColumn
          Caption = #26412#24180#21407#20540#22686#21152
          DataBinding.FieldName = 'sumdebit'
          Visible = False
          Width = 60
        end
        object colsumcredit: TcxGridDBColumn
          Caption = #26412#24180#21407#20540#20943#23569
          DataBinding.FieldName = 'sumcredit'
          Visible = False
          Width = 60
        end
        object colbastdebit: TcxGridDBColumn
          Caption = #26399#21021#21407#20540
          DataBinding.FieldName = 'bastdebit'
          Visible = False
          Width = 60
        end
        object colydprcredit: TcxGridDBColumn
          Caption = #24180#21021#32047#35745#25240#26087
          DataBinding.FieldName = 'ydprcredit'
          Visible = False
          Width = 60
        end
        object colsumdprdebit: TcxGridDBColumn
          Caption = #26412#24180#32047#35745#25240#26087#22686#21152
          DataBinding.FieldName = 'sumdprdebit'
          Visible = False
          Width = 60
        end
        object colsumdprcredbit: TcxGridDBColumn
          Caption = #26412#24180#32047#35745#25240#26087#20943#23569
          DataBinding.FieldName = 'sumdprcredbit'
          Visible = False
          Width = 60
        end
        object coldprcredit: TcxGridDBColumn
          Caption = #26399#21021#32047#35745#25240#26087
          DataBinding.FieldName = 'dprcredit'
          Visible = False
          Width = 60
        end
        object colydepramt: TcxGridDBColumn
          Caption = #26412#24180#35745#25552#25240#26087
          DataBinding.FieldName = 'ydepramt'
          Visible = False
          Width = 60
        end
      end
    end
  end
  inherited pnlBottom: TPanel
    Top = 368
    Width = 882
    Height = 55
    ExplicitTop = 368
    ExplicitWidth = 817
    ExplicitHeight = 55
    inherited chkGroupSort: TcxCheckBox
      Left = 375
      Top = 18
      ExplicitLeft = 375
      ExplicitTop = 18
      ExplicitWidth = 69
      ExplicitHeight = 20
    end
    inherited chkHandGroup: TcxCheckBox
      Left = 441
      Top = 18
      ExplicitLeft = 441
      ExplicitTop = 18
      ExplicitWidth = 69
      ExplicitHeight = 20
    end
    inherited lblGroupSort: TcxLabel
      Left = 514
      Top = 6
      ExplicitLeft = 514
      ExplicitTop = 6
      ExplicitWidth = 199
      ExplicitHeight = 44
      Height = 44
      Width = 199
    end
    inherited edtPause: TcxComboBox
      Left = 855
      Top = 18
      Visible = False
      ExplicitLeft = 790
      ExplicitTop = 18
      ExplicitHeight = 20
    end
    inherited btnOperator: TcxButton
      Top = 16
      ExplicitTop = 16
    end
    inherited chkGridFilter: TcxCheckBox
      Left = 734
      Top = 18
      ExplicitLeft = 669
      ExplicitTop = 18
      ExplicitWidth = 69
      ExplicitHeight = 20
    end
    inherited btnNew: TcxButton
      Top = 16
      TabOrder = 9
      ExplicitTop = 16
    end
    object chkAllField: TcxCheckBox
      Left = 808
      Top = 18
      Anchors = [akRight, akBottom]
      Caption = #26174#31034#25152#26377#21015
      Properties.OnChange = chkAllFieldPropertiesChange
      TabOrder = 6
      Transparent = True
      ExplicitLeft = 743
    end
    object btnModify: TcxButton
      Left = 192
      Top = 16
      Width = 90
      Height = 28
      Anchors = [akLeft, akBottom]
      Caption = #20462#25913
      TabOrder = 7
      OnClick = btnModifyClick
    end
    object btnDelete: TcxButton
      Left = 284
      Top = 16
      Width = 90
      Height = 28
      Anchors = [akLeft, akBottom]
      Caption = #21024#38500
      TabOrder = 8
      OnClick = btnDeleteClick
    end
  end
  inherited MainDataSource: TDataSource
    Left = 157
    Top = 123
  end
  inherited PopupMenu1: TPopupMenu
    inherited pmDeleteAllRecord: TMenuItem
      Visible = False
    end
  end
  inherited qyTmpDataSet: TUniQuery
    Left = 426
    Top = 106
  end
  inherited MainDataSetU: TUniQuery
    SQLInsert.Strings = (
      'INSERT INTO tfb_fixedassets'
      
        '  (fixedassetid, filid, newtypeid, statusid, fatypeid, deprmetho' +
        'did, addvoucherid, cardcode, assetcode, name, specific, location' +
        ', useddate, planusemonth, sumusedmonth, planworkvalue, sumworked' +
        'value, workunit, rawamt, sumdepramt, remainamt, remainrate, mont' +
        'hdepramt, monthdeprrate, deproption, cleared, addr, vendorname, ' +
        'producename, initflag, price, quantity, foreignamt)'
      'VALUES'
      
        '  (:fixedassetid, :filid, :newtypeid, :statusid, :fatypeid, :dep' +
        'rmethodid, :addvoucherid, :cardcode, :assetcode, :name, :specifi' +
        'c, :location, :useddate, :planusemonth, :sumusedmonth, :planwork' +
        'value, :sumworkedvalue, :workunit, :rawamt, :sumdepramt, :remain' +
        'amt, :remainrate, :monthdepramt, :monthdeprrate, :deproption, :c' +
        'leared, :addr, :vendorname, :producename, :initflag, :price, :qu' +
        'antity, :foreignamt)')
    SQLDelete.Strings = (
      'DELETE FROM tfb_fixedassets'
      'WHERE'
      '  fixedassetid = :Old_fixedassetid')
    SQLUpdate.Strings = (
      'UPDATE tfb_fixedassets'
      'SET'
      
        '  fixedassetid = :fixedassetid, filid = :filid, newtypeid = :new' +
        'typeid, statusid = :statusid, fatypeid = :fatypeid, deprmethodid' +
        ' = :deprmethodid, addvoucherid = :addvoucherid, cardcode = :card' +
        'code, assetcode = :assetcode, name = :name, specific = :specific' +
        ', location = :location, useddate = :useddate, planusemonth = :pl' +
        'anusemonth, sumusedmonth = :sumusedmonth, planworkvalue = :planw' +
        'orkvalue, sumworkedvalue = :sumworkedvalue, workunit = :workunit' +
        ', rawamt = :rawamt, sumdepramt = :sumdepramt, remainamt = :remai' +
        'namt, remainrate = :remainrate, monthdepramt = :monthdepramt, mo' +
        'nthdeprrate = :monthdeprrate, deproption = :deproption, cleared ' +
        '= :cleared, addr = :addr, vendorname = :vendorname, producename ' +
        '= :producename, initflag = :initflag, price = :price, quantity =' +
        ' :quantity, foreignamt = :foreignamt'
      'WHERE'
      '  fixedassetid = :Old_fixedassetid')
    SQLLock.Strings = (
      'SELECT * FROM tfb_fixedassets'
      'WITH (UPDLOCK, ROWLOCK, HOLDLOCK)'
      'WHERE'
      '  fixedassetid = :Old_fixedassetid')
    SQLRefresh.Strings = (
      
        'SELECT fixedassetid, filid, newtypeid, statusid, fatypeid, deprm' +
        'ethodid, addvoucherid, cardcode, assetcode, name, specific, loca' +
        'tion, useddate, planusemonth, sumusedmonth, planworkvalue, sumwo' +
        'rkedvalue, workunit, rawamt, sumdepramt, remainamt, remainrate, ' +
        'monthdepramt, monthdeprrate, deproption, cleared, addr, vendorna' +
        'me, producename, initflag, price, quantity, foreignamt FROM tfb_' +
        'fixedassets'
      'WHERE'
      '  fixedassetid = :Old_fixedassetid')
    SQL.Strings = (
      
        'select distinct fa.fixedassetid,fdt.name as fdtname,fa.newtypeid' +
        ' as newtypeid, '
      
        '                fnt.name as fntname,fa.statusid as statusid,fs.n' +
        'ame as fsname, '
      
        '                fa.fatypeid as fatypeid,ft.code as ftcode,ft.nam' +
        'e as ftname,fa.deprmethodid as deprmethodid, '
      
        '                fdm.name as fdmname,fa.initflag,fa.addvoucherid,' +
        ' '
      
        '                fa.cardcode,fa.assetcode,fa.name,fa.specific,fa.' +
        'location, '
      
        '                fa.useddate,fa.planusemonth,fa.sumusedmonth,fa.p' +
        'lanworkvalue, '
      
        '                fa.sumworkedvalue,fa.workunit,fa.rawamt,fa.sumde' +
        'pramt, '
      '                round((fa.rawamt-fa.sumdepramt),2) as netvalue, '
      
        '                fa.remainamt,fa.remainrate,fa.monthdepramt,fa.mo' +
        'nthdeprrate, '
      
        '                fa.deproption,fa.cleared,fa.addr,fa.vendorname,f' +
        'a.producename, '
      
        '                fa.price,fa.quantity,fa.foreignamt,m.name as mon' +
        'eyname, '
      
        '                sj.subcode + sj.subname as sjname,sjd.subcode + ' +
        'sjd.subname as dprsjname, '
      '                fa.filid,s.fi_filnm as filname, '
      '                fai.ybastdebit,fai.sumdebit,fai.sumcredit, '
      '                fai.bastdebit,fai.ydprcredit,fai.sumdprdebit, '
      '                fai.sumdprcredbit,fai.dprcredit,fai.ydepramt '
      '              from tfb_fixedassets fa '
      
        '              left join tfb_fixedassetsinit fai on fa.fixedasset' +
        'id=fai.fixedassetid '
      '              left join tfd_fixaststype ft on fa.fatypeid=ft.id '
      
        '              left join tfd_fixastsnewtype fnt on fa.newtypeid=f' +
        'nt.id '
      
        '              left join tfd_fixastsdeltype fdt on fa.fadeltypeid' +
        '=fdt.id '
      
        '              left join tfd_fixastsstatus  fs on fa.statusid=fs.' +
        'id '
      
        '              left join tfd_fixastsdeprmethod fdm on fa.deprmeth' +
        'odid=fdm.id '
      
        '              left join tfd_subject sj on fa.astsubid=sj.subject' +
        'id '
      
        '              left join tfd_subject sjd on fa.dprsubid=sjd.subje' +
        'ctid '
      '              left join td_money m on fa.foreigncurid=m.moneyid '
      '              left join td_filiale s on fa.filid=s.fi_filid')
    Left = 248
  end
end
